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