UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'arrjdnTIYq6rIS5hV/bVw/13YK0fky5/n3PSNcPhp0c=' 
WHERE 
  key_id = '85a2d4e51af6d746224724c1f35dadd4af28f188f3331ba2fd33cf34fd376320' 
  AND (
    token = 'arrjdnTIYq6rIS5hV/bVw/13YK0fky5/n3PSNcPhp0c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00058