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