UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oCYavbjsDOzzDWQMCrXDWFzgNsH+87lZu79lJhbOeuc='
WHERE
key_id = 'd717ee331d84be6bbac9b9afbb6a3ea9062190a7b6f049db142ee211f6a445d1'
AND (
token = 'oCYavbjsDOzzDWQMCrXDWFzgNsH+87lZu79lJhbOeuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)