UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJuNS1s/pl+dcAc8CWPs7zyRG17J4Rj6SBphk+NLOyA='
WHERE
key_id = '9046aebdafc21b18f0ccfd65b69e2202044efa6af1eeb60a9a46c879af231b14'
AND (
token = 'DJuNS1s/pl+dcAc8CWPs7zyRG17J4Rj6SBphk+NLOyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)