UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UU4gAZS8icEgdbGpV9qjGCtvi27myjN8n1S+YXXhSHk='
WHERE
key_id = 'b62747c570aa6e99d25d17253c836bef5e44ea68387af382c8b74e6169e79f45'
AND (
token = 'UU4gAZS8icEgdbGpV9qjGCtvi27myjN8n1S+YXXhSHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)