UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgCncIeGPI2d1s62qcOoq0rrEITCFvHU77Zhdq4DAQ8='
WHERE
key_id = '40bd78c25549e8221e9414bcb582b82454e93914df4e957bf8dbd01e202d0f8c'
AND (
token = 'lgCncIeGPI2d1s62qcOoq0rrEITCFvHU77Zhdq4DAQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)