UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XwJIRMPJSBswyRqH8o97A8hX6guXdJbPoT2F3/VOyW4='
WHERE
key_id = '3ff9226cbe71f1a59cbdaa9bea01c0de18974679ee974b9009136e11bbcd2e27'
AND (
token = 'XwJIRMPJSBswyRqH8o97A8hX6guXdJbPoT2F3/VOyW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)