UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zjXTHyWhzFaYEPvx1cXLLaJ5fjLqC5rGrD25/DnasZE='
WHERE
key_id = 'c662f382e226fcdf637a0fbad3739ac6035b81e00c4a58dab4fbb74281449ae3'
AND (
token = 'zjXTHyWhzFaYEPvx1cXLLaJ5fjLqC5rGrD25/DnasZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)