UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7HeCUPisn+fvanW9sKNs9r56iqWlM2AqAsjagTmGa2E='
WHERE
key_id = 'cd42a9a490f5fc9f1d4810953f27bb5e6e38586cdc56d178f811731c77732c80'
AND (
token = '7HeCUPisn+fvanW9sKNs9r56iqWlM2AqAsjagTmGa2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)