UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XCHV3Mc5LHTG4cnZsTVxBAj0lQgkSr8xGfbWZNLcqd4='
WHERE
key_id = '23746272996aa25c108d7c20235061f9aa0d008014778c1a37c25ed65c5191c2'
AND (
token = 'XCHV3Mc5LHTG4cnZsTVxBAj0lQgkSr8xGfbWZNLcqd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)