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