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