UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WVJLagboDobid4ij0BKQULG1M0h2vEk5VKJDs717XFE='
WHERE
key_id = 'a4c038d053f355d671b9d0bbec7540be31bc74eeadc0759cd016b1b52f8f3874'
AND (
token = 'WVJLagboDobid4ij0BKQULG1M0h2vEk5VKJDs717XFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)