UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hI+PR86q0MYKEZt09n8lgrZ3pDfuD9jW45Umw11cA2Y=' 
WHERE 
  key_id = 'cb660fdc5fc972e88b8b926db7a4c7eeb45e073080ab141f10aad3b752528092' 
  AND (
    token = 'hI+PR86q0MYKEZt09n8lgrZ3pDfuD9jW45Umw11cA2Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021