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