UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ePiPExgCLhRYcgMi2GoWWK0hobM6Vm0ho8hlnvtknE='
WHERE
key_id = '3ad750df1e8d527b640e0217da72d80cb5d119cf73915f07ece3f1b994ee094a'
AND (
token = '6ePiPExgCLhRYcgMi2GoWWK0hobM6Vm0ho8hlnvtknE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)