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