UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rr7WdsySnLyngcGixgZ8jEpECf//rgX9MVuSoojhm5Q='
WHERE
key_id = 'a83e50b32f0c2351a44677bb61f2a40ef920f8889adc573b0d23f537329f6f65'
AND (
token = 'rr7WdsySnLyngcGixgZ8jEpECf//rgX9MVuSoojhm5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)