UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cOtsLERUybj37QcYyZMH9361mi/huHzelJun5giBggI='
WHERE
key_id = '7a26e9c69a1866cecf0de99506f0714fcaff5039c349fcd77ed2a1b382188265'
AND (
token = 'cOtsLERUybj37QcYyZMH9361mi/huHzelJun5giBggI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)