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

Query time 0.00046