UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mxQszE4nYDfag/HNGXrm8c8ISKC1WZnGwCxy42hD+MQ='
WHERE
key_id = 'debc9622a0f99a71f9ce90e08e9078a63f68056fbe526ffc7186cd6909ba5b01'
AND (
token = 'mxQszE4nYDfag/HNGXrm8c8ISKC1WZnGwCxy42hD+MQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)