UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xA9fbRfzsHWWIPjTlrca6u5zBjb5d+le8tqr9KirOqI='
WHERE
key_id = 'd02757b2de2e0b2d3bb1dc14efac9112412896f5801b6fbc0ec46308475c36d4'
AND (
token = 'xA9fbRfzsHWWIPjTlrca6u5zBjb5d+le8tqr9KirOqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)