UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jpheghVWN7DDeAT3Fg0NJH2v+wcumbVekiO4WxHBwoo=' 
WHERE 
  key_id = 'd1febf17ae3ab873cbeba9baf559a234a9f655ee18939e756ef77ea38b7e4a7e' 
  AND (
    token = 'jpheghVWN7DDeAT3Fg0NJH2v+wcumbVekiO4WxHBwoo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00062