UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8425pETiB3JOL97/YBpNfYdeDpR0CE2g9XxvEqDGqRs='
WHERE
key_id = '512b95684746527429a216a72c1da4f06944cdf218a5e872f0bfd804177b030d'
AND (
token = '8425pETiB3JOL97/YBpNfYdeDpR0CE2g9XxvEqDGqRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)