UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1y+TMY2zTt4Ec7XHnpgZCBtNu7dMucD1e0MgPdVRFvw=' 
WHERE 
  key_id = 'd4e4cc0eccd49926a011ae3907fd0e06eef742b4f69a1011638217dee4fcb3e2' 
  AND (
    token = '1y+TMY2zTt4Ec7XHnpgZCBtNu7dMucD1e0MgPdVRFvw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027