UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ME31CqfE/fI4W7/9amYnL5v6esP2i3OjvFBnUcFVS3c='
WHERE
key_id = 'd223b42b2885ee280cd1bb2d6c34919e1d9c4238ce021c28b3e575febd0b405b'
AND (
token = 'ME31CqfE/fI4W7/9amYnL5v6esP2i3OjvFBnUcFVS3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)