UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MIMza6aXDea69zvJdyf/2wyJhwa/DQynRMn6r7EypYw='
WHERE
key_id = 'bb2a7d2aca6db61e89af47bc53cb5ee99e4cffadb6eaa47e254bd75684f0b5dd'
AND (
token = 'MIMza6aXDea69zvJdyf/2wyJhwa/DQynRMn6r7EypYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)