UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8R7n33tt8Yd8RwlhPD/4n5KN2bq9Y9cnSqG7HvT3RLg='
WHERE
key_id = '0642155251507c667bf57e6eb6e975aea5610f4f0777b7665a2ff68766ac6bc0'
AND (
token = '8R7n33tt8Yd8RwlhPD/4n5KN2bq9Y9cnSqG7HvT3RLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)