UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1DvJRojqF4dr5eZFZ2aQJQ4xbxegREoz6kRS5cOC7rg='
WHERE
key_id = 'c89e2dc8ec300abc99ab08b23ecd54ed5b5ce3d9731a613831dbcf7290de2c95'
AND (
token = '1DvJRojqF4dr5eZFZ2aQJQ4xbxegREoz6kRS5cOC7rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)