UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XUMRe5Zl6E3VbsQpcP0SLX3siUCHac+YuT1WKHyg9s0='
WHERE
key_id = '274da875dd5651c03cb792737b0e170a79c5dd9ab2fd5a93be9df3ff023eef01'
AND (
token = 'XUMRe5Zl6E3VbsQpcP0SLX3siUCHac+YuT1WKHyg9s0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)