UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLexR5UtRPaZfGA1GwPrav/uU3o466ie+SJWg4o7GSI='
WHERE
key_id = 'cd7b0ab11d195992dd6324614327f25a8c27533ef25e38e798044b9bd107f17f'
AND (
token = 'ZLexR5UtRPaZfGA1GwPrav/uU3o466ie+SJWg4o7GSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)