UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NsTJTVQBD31EMAL0vf3SfBpqXi0w3RSJGbac7oYw9ag='
WHERE
key_id = 'e959f3bfcf5807c5e1d4c963b8937b89db1b04e7111a6fedc51f9c74e5f7043e'
AND (
token = 'NsTJTVQBD31EMAL0vf3SfBpqXi0w3RSJGbac7oYw9ag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)