UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgQEhTitFVmckGD6zhKJqDHnjhy5LXbyMgIF+BwrKkU='
WHERE
key_id = '3eaadc598425d706999ff9f74eb9e73870c46e541e6a2c2279b240c6c15be7a7'
AND (
token = 'ZgQEhTitFVmckGD6zhKJqDHnjhy5LXbyMgIF+BwrKkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)